﻿CREATE TABLE [dbo].[BillingPayToProvider]
(
[HierarchicalIDNumber] [nvarchar] (12) NULL,
[HierarchicalLevelCode] [nvarchar] (2) NULL,
[HierarchicalChildCode] [nvarchar] (1) NULL,
[ProviderCode] [nvarchar] (3) NULL,
[ReferenceIdentificationQualifier] [nvarchar] (3) NULL,
[ProviderTaxonomyCode] [nvarchar] (30) NULL,
[ProviderEntityIdentifierCode] [nvarchar] (3) NULL,
[ProviderCurrencyCode] [nvarchar] (3) NULL,
[BillingProviderEntityIdentifierCode] [nvarchar] (3) NULL,
[BillingProviderEntityTypeQualifier] [nvarchar] (1) NULL,
[BillingProviderLastOrOrganizationalName] [nvarchar] (35) NULL,
[BillingProviderIdentificationCodeQualifier] [nvarchar] (2) NULL,
[BillingProviderIdentifier] [nvarchar] (80) NULL,
[BillingProviderAddressLine1] [nvarchar] (55) NULL,
[BillingProviderAddressLine2] [nvarchar] (55) NULL,
[BillingProviderCityName] [nvarchar] (30) NULL,
[BillingProviderStateOrProvinceCode] [nvarchar] (2) NULL,
[BillingProviderZIPCode] [nvarchar] (15) NULL,
[BillingProviderCountryCode] [nvarchar] (3) NULL,
[BillingProviderSecondaryIdentificationQualifier] [nvarchar] (3) NULL,
[BillingProviderAdditionalIdentifier] [nvarchar] (30) NULL,
[CreditDebitCardBillingInformationQualifier] [nvarchar] (3) NULL,
[BillingProviderCreditCardIdentifier] [nvarchar] (30) NULL,
[BillingProviderContactFunctionCode] [nvarchar] (2) NULL,
[BillingProviderContactName] [nvarchar] (60) NULL,
[BillingProviderCommunicationNumberQualifier1] [nvarchar] (2) NULL,
[BillingProviderCommunicationNumber1] [nvarchar] (80) NULL,
[BillingProviderCommunicationNumberQualifier2] [nvarchar] (2) NULL,
[BillingProviderCommunicationNumber2] [nvarchar] (80) NULL,
[BillingProviderCommunicationNumberQualifier3] [nvarchar] (2) NULL,
[BillingProviderCommunicationNumber3] [nvarchar] (80) NULL,
[PayToProviderEntityIdentifierCode] [nvarchar] (3) NULL,
[PayToProviderEntityTypeQualifier] [nvarchar] (1) NULL,
[PayToProviderLastOrOrganizationalName] [nvarchar] (35) NULL,
[PayToProviderIdentificationCodeQualifier] [nvarchar] (2) NULL,
[PayToProviderIdentifier] [nvarchar] (80) NULL,
[PayToProviderAddressLine1] [nvarchar] (55) NULL,
[PayToProviderAddressLine2] [nvarchar] (55) NULL,
[PayToProviderCityName] [nvarchar] (30) NULL,
[PayToProviderStateOrProvinceCode] [nvarchar] (2) NULL,
[PayToProviderZIPCode] [nvarchar] (15) NULL,
[PayToProviderCountryCode] [nvarchar] (3) NULL,
[PayToProviderSecondaryIdentificationQualifier] [nvarchar] (3) NULL,
[PayToProviderAdditionalIdentifier] [nvarchar] (30) NULL,
[GroupControlNumber] [nvarchar] (9) NULL,
[InterchangeControlNumber] [nvarchar] (9) NULL,
[GroupIDKey] [int] NULL,
[BillingPayToProviderIDKey] [int] NOT NULL IDENTITY(1, 1),
[TransactionSetControlNumber] [nvarchar] (9) NULL,
[InterchangeIDKey] [int] NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL
) ON [PRIMARY]


GO
EXEC sp_addextendedproperty N'Function', N'Used primarity lin the 837 Claim process', 'SCHEMA', N'dbo', 'TABLE', N'BillingPayToProvider', NULL, NULL

